﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using iMall.AtoZ.Helper;
using System.Data;

namespace iMall.AtoZ
{
    public partial class Test : System.Web.UI.Page
    {
        private string path = @"";
        protected void Page_Load ( object sender, EventArgs e )
        {
            //string sql = string.Format("select * from OrderInfo");

            //DataSet src = SqlDALHelper.ExecuteSQLDataSet(sql);
            //foreach ( DataRow dr in src.Tables[0].Rows )
            //{
            //    OrderInfoEnity entity = AtoZUtility.GetOrderInfoEnityFromDataRow(dr);
            //    DALFactory.GetOrderInfoDAL().Insert(entity);
            //}

            //DataSet ds = GemBoxExcelLiteHelper.LoadExcel(path,"" ,HDRString.YES, "db");
            //GemBox.ExcelLite.ExcelFile excel = new GemBox.ExcelLite.ExcelFile();
            //excel.LoadXls(path);
        }

        public string WebURL
        {
            get { return this.Request.Url.AbsoluteUri.Replace(this.Request.Url.PathAndQuery, "/"); }
        }

        public string LocalURL
        {
            get { return this.Request.Url.AbsoluteUri.Replace(this.Request.Url.PathAndQuery, "/"); }
        }

        protected void Button1_Click ( object sender, EventArgs e )
        {
            DataSet ds = GemBoxExcelLiteHelper.LoadExcel(path,"", HDRString.YES, "db");   
        
        }
    }
}